﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FL.DBModule.Sys;
using NPOI;

namespace FL.Export
{
    public class ExportExecl
    {
            //DataTable dt = helper.ExecuteDataTable(querySql);
            //dt.TableName = "A";
            //if (dt.Rows.Count == 0)
            //    return;
            //WorkbookDesigner designer = new WorkbookDesigner();
            //designer.Open(MapPath("~/Templete/book1.xls"));
            //designer.SetDataSource(dt);
            //designer.Process();             
            //designer.Save(string.Format("JH-report.xls"), SaveType.OpenInExcel, FileFormatType.Excel2003, Response);
            //Response.Flush();
            //Response.Close();
            //designer = null;
            //Response.End(); void ExportFile()

        public void ExportFile(IList<FL.DBModule.Sys.t_set_datagrid> datagrid,System.Data.DataTable dt)
        {

        }
    }
}
